-- create new database
USE master
GO
CREATE DATABASE mydb
ON 
( NAME = mydb_dat,
   FILENAME = 'c:\awork\database\mydb.mdf',
   SIZE = 10,
   FILEGROWTH = 5 )
LOG ON
( NAME = 'Sales_log',
   FILENAME = 'c:\awork\database\mydb.ldf',
   SIZE = 5MB,
   MAXSIZE = 25MB,
   FILEGROWTH = 5MB )
GO


